package pe.com.bn.sach.service;

import java.util.Date;
import java.util.Hashtable;
import java.util.List;

import pe.com.bn.sach.domain.Bnchf03Motivo;
import pe.com.bn.sach.domain.Bnchf05Observaciones;
import pe.com.bn.sach.domain.Bnchf06Tabla;
import pe.com.bn.sach.domain.Bnchf07Item;
import pe.com.bn.sach.domain.Bnchf09Profesion;
import pe.com.bn.sach.domain.Bnchf10Instruccion;
import pe.com.bn.sach.domain.Bnchf11Nacionalidad;
import pe.com.bn.sach.domain.Bnchf18Destino;
import pe.com.bn.sach.domain.Bnchf19Modalidad; 
import pe.com.bn.sach.domain.Bnchf55Moneda;
import pe.com.bn.sach.domain.BnchfxxAgencia;

import pe.com.bn.sach.domain.Bnchf08Ubigeo;

public interface SelectService {
	
	
	public List liststadodesembolso() throws Exception;
	public Hashtable ObservacionesComentarios(String idExpediente)throws Exception;
	public List listaCentroHipotecarioActivos() throws Exception;
	public BnchfxxAgencia encontrarAgencia2(String idDept4);
	public List diasBloqueoRegistral() throws Exception;
	public List diasAprobCrediticia() throws Exception;
	public List listarmoneda() throws Exception;
	public List listCentroHiptecario() throws Exception;
	public List listHipotecarioUsuario(Long usuario) throws Exception;
	public List listPrograma() throws Exception;
	public List listGrupoObjetivo() throws Exception;
	public List listDestino() throws Exception;
	public List listModalidad() throws Exception;
	
	public List listModalidad(Bnchf19Modalidad bnchf19Modalidad) throws Exception;
	public List listItemEstadoInmueble() throws Exception;
	public List listAgencia() throws Exception;	 
	public List listarAgenciaDisponibles() throws Exception;
	public String validaAgenciaAsignadas(String idAgencia);
	public List listSituacionLaboral() throws Exception;
	public List listContrato() throws Exception;
	public List listItem(Bnchf07Item bnchf07Item) throws Exception;
	
	public List listItemDNI() throws Exception;
	public List listItemEstadoCivil() throws Exception;
	public List listItemSexo() throws Exception;
	public List listNacionalidad(Bnchf11Nacionalidad bnchf11Nacionalidad) throws Exception;
	public List listProfesion(Bnchf09Profesion bnchf09Profesion) throws Exception;
	public List listInstruccion(Bnchf10Instruccion bnchf10Instruccion)
	throws Exception;
	public int listPreDiasBloqueo() throws Exception;
	
	public List lisParentesco() throws Exception;
	public List listUbigeo(Bnchf08Ubigeo bnchf08Ubigeo) throws Exception;
	public List listItemTipoUBicacion() throws Exception;
	
	public List listDepartamento(Bnchf08Ubigeo bnchf08Ubigeo) throws Exception;
	public List listProvincia(Bnchf08Ubigeo bnchf08Ubigeo) throws Exception;
	public List listDistrito(Bnchf08Ubigeo bnchf08Ubigeo) throws Exception;
	
	public List listItemEstadoCliente() throws Exception;
	public List listBancos(Bnchf07Item bnchf07Item)
	throws Exception;
	
	public List listItemTipoDesgravamen() throws Exception;
	public List listItemDobleJulio() throws Exception;
	public List listItemDobleDiciembre() throws Exception;
	public List listItemComprobanteDomicilio() throws Exception;
	
	// motivo y objservaiones	
	public List listMotivo(Bnchf03Motivo bnchf03Motivo) throws Exception;
	public Bnchf03Motivo encontrarMotivo(Bnchf03Motivo bnchf03Motivo) throws Exception;
	//observacion
	public List listObservaciones(Bnchf05Observaciones bnchf05Observaciones) throws Exception;
	public Bnchf05Observaciones  encontrarObservaciones(Bnchf05Observaciones bnchf05Observaciones) throws Exception;
	
	public List listTipInterior()
	throws Exception;

	public List listTipExterior()
	throws Exception;

	public List listTipVia()
	throws Exception;
	
	public List listTipZona()
	throws Exception;
	
	
	//Vilia 
	
	public void guardarTabla(Bnchf06Tabla bnchf06Tabla) throws Exception;
	public void actualizarTabla(Bnchf06Tabla bnchf06Tabla) throws Exception;
	public List buscarTabla(Bnchf06Tabla bnchf06Tabla) throws Exception;
	public List listarTabla(Bnchf06Tabla bnchf06Tabla) throws Exception;
	public void guardarItem(Bnchf07Item bnchf07Item) throws Exception;
	public void actualizarItem(Bnchf07Item bnchf07Item) throws Exception;
	public List buscarItem(Bnchf07Item bnchf07Item) throws Exception;
	public List listarItem(Bnchf07Item bnchf07Item) throws Exception;
	
	//add wilber
	
	public List listMoneda(Bnchf55Moneda bnchf55Moneda) throws Exception;	
	public List listUbigeoDepartamento() throws Exception;
	public List listUbigeoProvincia(Bnchf08Ubigeo bnchf08Ubigeo) throws Exception;
	public List listUbigeoDistrito(Bnchf08Ubigeo bnchf08Ubigeo) throws Exception;
	public Bnchf08Ubigeo encontrarDistrito(Bnchf08Ubigeo bnchf08Ubigeo) throws Exception;
	public BnchfxxAgencia encontrarAgencia(BnchfxxAgencia bnchfxxAgencia) throws Exception;
	public List listAgencia(BnchfxxAgencia bnchfxxAgencia) throws Exception;	
	public List listProducto() throws Exception;
	
	public Bnchf18Destino encontrarDestino(Bnchf18Destino bnchf18Destino) throws Exception;
	
}
